A. Preparation

  1. Connect to CyberArk for secure credentials and confirm permission to modify MSB PTS records for the relevant country scope.
  2. Open the DBeaver database tool and ensure the required drivers and connections are available.
  3. In DBeaver, open the script file: MBS-PTS-Queries.sql

B. Choose DB & account numbers

  1. Select the correct database for the target country: 
    KE-MSB-PR-DB | TZMSB-PR-DB | UG-MSB-PR-DB

    i When unsure, re-check instructions in the request or confirm with a lead before proceeding.

  2. Prepare account numbers in the expected SQL format: 
    -- Example:
WHERE account_number IN ('1234567890','0987654321','...')

    i Each account number must be inside single quotes and separated by commas for a valid IN clause.

C. Execute and verify

  1. Execute the query for the selected database and confirm that removed records no longer appear in results or validation queries.
  2. Capture screenshots of execution and results as confirmation artifacts for the request trail.
    Evidence screenshots

    i Replace local image paths with accessible, hosted URLs or repository-relative assets to ensure portability across environments.

  3. Common errors & fixes
    ! Syntax error: check single quotes and commas; Permission denied: confirm DB role and session; No records found: validate accounts; Connection issues: verify VPN, reconnect CyberArk, or restart DBeaver.

Notes & tips

Disclosures and a11y

i Use native <details>/<summary> for collapsible content to keep guidance accessible and keyboard-operable per platform recommendations.

Sticky navigation

i The TOC uses position: sticky with a top offset so links remain in view within the container during scroll.

Semantic structure

i Sections, headings, and lists improve scanability and assistive technology parsing; keep headings clear and ordered for consistent navigation.